<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<%@ page import="javax.sql.*" %>
<%@ page import="javax.naming.*" %>
<%@ page import="com.asiainfo.database.*" %>


<%
   Context ctx = null;
   DataSource ds = null;
   Connection conn = null;
   Statement handle=null;
   CallableStatement ps=null;
   ResultSet rst = null;
   String strsql="";
   Sqlca m_Sqlca = null;
   Sqlca sqlca = null;
   try
   {
      ctx = new InitialContext();
      m_Sqlca = new Sqlca(new ConnectionEx());
      sqlca = new Sqlca(m_Sqlca.getConnection());
      ds = (DataSource)ctx.lookup("java:comp/env/jdbc/oracle");
      conn = ds.getConnection();
      handle=conn.createStatement();

   }catch(Exception e)
   {
      System.out.println(e.getMessage());
      out.write("<script language=vbscript>\n msgbox \"database error\"\n</script>\n");
   }

   try
   {
%>
